CustomerOrderAccount

Entity Definition

Logical Name : CustomerOrderAccount
Physical Name : LE_CT_ORD_ACNT

A type of CustomerAccount established when a customer places an order with the retailer and chooses to persist their contact information and a method of payment. This type of account does NOT extend credit it simply provides a pre-established collection of customer data to make ordering easier. It also provides the basis for tracking multiple orders for a customer

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
CustomerAccountID (FK)(PK)	A unique identifier for a customer account.	ID_CTAC	Identity	integer
DefaultShipTo (FK)	A token identifier for a PartyContactMethod entity type instance.	ID_PRTY_CNCT_MTH	Identity	integer	PartyContactMethod(CO_MTH_CNCT_PTY)

Relationships

Parent Entity	Verb Phrase	Child Entity
PartyContactMethod	is default for	CustomerOrderAccount
CustomerOrderAccount	places	CustomerOrder
CustomerOrderAccount	is billed by	CustomerAccountInvoice

Logical Views containing CustomerOrderAccount

Logical View
Logical 07010 - Customer Account Information Extended